SUPPORT / SAMPLES & SAS NOTES
 

Support

Usage Note 56412: An "Unparseable data" exception occurs when you use the Release Tables utility in SAS® Customer Intelligence

DetailsAboutRate It

When you use the Release Tables (-releaseTables) utility in SAS Customer Intelligence, the utility might fail with an exception similar to the following:

D:\Program Files\SASCustomerIntelligenceUtilities\6.3>sasciutils.exe -releaseTables -userid sasdemo 
-password password -utilitylogfile c:/temp/cleanup.log -deldate "May 06, 2015"

ERROR 2015-08-03 16:56:59: Exception: Unparseable date: "May 06, 2015"

This problem occurs because an incorrect delete-date format (-deldate) is used. The -deldate format uses the default locale and the medium length format for the locale.

For this particular example, the locale is English (United Kingdom) locale, and the format should be DD-MMM-YYYY (06-May-2015). To resolve such a problem, you need to ensure that you have the correct format for your locale. For a list of all International Organization for Standardization (ISO) formats that are used with Java, see Java Dates. This document lists the short, medium, and long length formats for each locale (language/country).



Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS Customer Intelligence UtilitiesHP-UX IPF6.1_M16.1_M19.3 TS1M0
64-bit Enabled Solaris6.1_M16.1_M19.3 TS1M0
64-bit Enabled AIX6.1_M16.1_M19.3 TS1M0
Windows Vista for x646.1_M16.1_M19.3 TS1M0
Windows Vista6.1_M16.1_M19.3 TS1M0
Windows 7 Ultimate x646.1_M16.1_M19.3 TS1M0
Windows 7 Ultimate 32 bit6.1_M16.1_M19.3 TS1M0
Windows 7 Professional x646.1_M16.1_M19.3 TS1M0
Windows 7 Professional 32 bit6.1_M16.1_M19.3 TS1M0
Windows 7 Home Premium x646.1_M16.1_M19.3 TS1M0
Windows 7 Home Premium 32 bit6.1_M16.1_M19.3 TS1M0
Windows 7 Enterprise x646.1_M16.1_M19.3 TS1M0
Windows 7 Enterprise 32 bit6.1_M16.1_M19.3 TS1M0
Microsoft Windows XP Professional6.1_M16.1_M19.3 TS1M0
Microsoft Windows Server 2008 for x646.1_M16.1_M19.3 TS1M0
Microsoft Windows Server 2008 R26.1_M16.1_M19.3 TS1M0
Microsoft Windows Server 20086.1_M16.1_M19.3 TS1M0
Microsoft Windows Server 2003 for x646.1_M16.1_M19.3 TS1M0
Microsoft Windows Server 2003 Standard Edition6.1_M16.1_M19.3 TS1M0
Microsoft Windows Server 2003 Enterprise Edition6.1_M16.1_M19.3 TS1M0
Microsoft Windows Server 2003 Datacenter Edition6.1_M16.1_M19.3 TS1M0
Microsoft® Windows® for x646.1_M16.1_M19.3 TS1M0
Linux for x646.1_M16.1_M19.3 TS1M0
Solaris for x646.1_M16.1_M19.3 TS1M0
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.